| Purpose |
To add LA7 in the UPC program and update logic for Dual Currency in Material Input |
| Release No |
002 |
| Submitted on |
10/09/2015 |
| Submitted by |
Siba Mohapatra |
| Environment |
NECNED to NECNEQ |
| Sent To |
Lizz Paxson |
| Object(s) created by |
Mahesh |
| Object(s) tested by |
Siba/Deepak |
| Transport Status |
Created in NECNED100 |
| Sl. |
Transport ID |
Description |
Object Name |
| 1 |
NEDK931696 |
SD:21437:Added LA7 & logic updtd for Dual curcy-Mat. Input |
ZRSD_UPC_LABELS |
| Test ID |
Test Scenarios |
Expected Results |
Actual Results |
P/F |
Document # |
Tested By |
QA By |
| SD001 |
For Stock items: Create a Production order execute in ZSD_UPCLBL T.code under UPC(stock items only). |
The condition record should be fetched from the below tables in series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type As the entry in 901 table is deleted i.e. with customer NEC0135 and VAS mat.grp APL the entry of 906 table is considered for the L and S codes ie., LA7 and S31 |
As expected, appropriate Label printed from the required table. |
P |
Prod.order – 1000009693 Sorg – 1000 Cur - USD |
Siba |
Deepak |
| SD002 |
For Stock items: Execute ZSD_UPCLBL t.code with the below inputs. Material,size,qty,S.org,cur,MSRP |
The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type As the 901 table condition record has been deleted the L and S codes from 906 table should be considered to print the labels LA7 and S31 with the given input quantities. |
As expected, appropriate Label printed from the required table. |
P |
Material – 10000218 Size – 612 qty – 5 S.org – 1000 Cur – USD MSRP – any value as input. |
Siba |
Deepak |
| SD003 |
For Stock items: Create a Purchase order with some deleted materials (EA) and execute in ZSD_UPCLBL T.code under UPC(stock items only) with print components flagged. |
The condition record should be fetched from the below tables in series. KOTK912 (Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr) KOTK901 (Sales org./Distr. Chl/Division/Customer/VAS Mat.gr) KOTK922 (Sales org./Distr. Chl/Division/Plant) Only the undeleted material sizes should get printed in the output. Labels should be printed from table 912, as there is an entry exist in table 912 i.e. with Sorg-1000, Dist.chnl-10, Div-00, Plant-0110, VAS mat.gr- HDW & VAS Code- LA7, S31. |
As expected, appropriate Label printed from the required table. |
P |
PO - 4600005479 |
Siba |
Deepak |
| SD004 |
For Customer Specific items: Create MTO sales order with no L codes and corresponding Production order and execute in ZSD_UPCLBL T.code. |
The condition record should be fetched from KOTK901 table ie., Sales org./Distr. Chl/Division/Customer/VAS Mat.gr There is no VAS code maintained in the sales order, then the VAS codes will be picked from 901 table. which has been maintained with Sorg-1000, Distchnl- 10, Div-00, Cust- 1000018, VAS mat. grp- HDW. With LA7 & S31. |
As expected, appropriate Label printed from the required table. |
P |
Production order - 1000009718 |
Siba |
Deepak |
| SD005 |
For Customer specific labels: Create a SO with VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels |
Program will check first sales order for VAS Condition maintained or not then it will check table 901. As sales order has maintained VAS code i.e LA7 , S31 and it will be printed. |
As expected, appropriate Label printed from the required table. |
P |
SO - 71622 |
Siba |
Deepak |
| SD006 |
For Customer specific labels: Create a SO with same VAS codes for all items and execute in ZSD_UPCLBL T.code under customer specific labels with below inputs. SO number,material number from the SO,size,qty |
The VAS codes in the SO (LA7,S31) for the given item should be considered for printing the labels with the given quantities. |
As expected, appropriate Label printed from the required table. |
P |
SO – 71622 Material – 10000218 Size – 658 Qty - 5 |
Siba |
Deepak |
| SD007 |
For Customer specific labels: Execute ZSD_UPCLBL t.code with the below inputs. S.org,Cust,Material,size,Qty |
The L and S codes should be fetched from the below tables in series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type The condition record in 901 table with Cust 1000018 and VAS material grp HDW is considered to print labels ie., LA7, S31 with the given input quantities. |
As expected, appropriate Label printed from the required table. |
P |
S.org – 1000 Customer – 1000018 Material – 10000218 Size – 678 Qty – 5 |
Siba |
Deepak |
| Test ID |
Test Scenarios |
Expected Results |
Actual Results |
P/F |
Document # |
Tested By |
QA By |
| SD001 |
For Stock items: Execute ZSD_UPCLBL t.code with the below inputs. Material,size,qty,S.org,cur,MSRP |
The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK904 Sales org. KOTK922 Sales org./Distr. Chl/Division/Plant When multiple condition record available i.e for table 901 & 904. Then the condition record from 901 table should be used to print the labels ie., LBJ,S23 with given input quantities. |
As expected, appropriate label printed form required table. |
P |
Material – 10014184 Size – OSFA qty – 5 S.org – 2000 Cur – GBP MSRP – Blank |
Siba |
Deepak |
| SD002 |
For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only) |
The condition record should be fetched from the below tables in a series. KOTK912 Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant As the condition record is maintained in 912 table. The condition record from 912 table should be used to print the labels ie., LBJ,S23 with given input. |
As expected, appropriate label printed form required table. |
P |
PO - 4600008520 |
Siba |
Deepak |
| SD003 |
For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only) |
The condition record should be fetched from the below tables in a series. KOTK912 Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant When multiple condition record available i.e for table 912 & 901. And the condition record from table 912 is deleted. Then the condition record from 901 table should be used to print the labels ie., LBJ,S23 with given input. |
As expected, appropriate label printed form required table. |
P |
PO - 4600008520 |
Siba |
Deepak |
| SD004 |
For Stock items: Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only) Check Print component |
The condition record should be fetched from the below tables in a series. KOTK912 Sales org./Distr. Chl/Division/Customer/Plant/VAS Mat.gr KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK922 Sales org./Distr. Chl/Division/Plant When multiple condition record available i.e for table 912 & 901. And the condition record from table 912 is deleted. Then the condition record from 901 table should be used to print the labels ie., LBJ,S23 with given input. PO components should be printed with above L & S code. |
As expected, appropriate label printed form required table. |
P |
PO - 4600005480 |
Siba |
Deepak |
| SD005 |
For Customer specific labels: Create a SO with no VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels |
The condition record should be fetched from the below tables in series. First from sales order then from below 901 table. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr When multiple condition records available i.e at Sales order and table 901. Then from Sales order, L & S codes will be printed i.e LBJ & S23 |
As expected, appropriate label printed form required table. |
P |
SO- 69164 |
Siba |
Deepak |
| SD006 |
For Customer specific labels: Create a SO with no VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels |
The condition record should be fetched from the below tables in series. First from sales order then from below 901 table. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr When L & S codes are not maintained in sales order, then from table 901 L & S codes will be printed i.e LBJ & S23. |
As expected, appropriate label printed form required table. |
P |
SO- 71656 |
Siba |
Deepak |
| SD007 |
For Customer specific labels: Create a SO with no VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels with below inputs. SO number,material number from the SO,size,qty |
The condition record should be fetched from the below tables in series. First from sales order then from below 901 table. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr When L & S codes are not maintained in sales order, then from table 901 L & S codes will be printed i.e LBJ & S23. The condition record is read from the 901 table only with customer NEC0135 and VAS mat.grp HDW with the given input quantities. |
As expected, appropriate label printed form required table. |
P |
SO –71656 Material – 10000219 Size – 678 Qty - 2 |
Siba |
Deepak |
| SD008 |
For Customer specific labels: Create a SO with no VAS codes and execute in ZSD_UPCLBL T.code under customer specific labels with below inputs. SO number,material number from the SO,size,qty |
The condition record should be fetched from the below tables in series. First from sales order then from below 901 table. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr When multiple condition records available i.e at Sales order and table 901. Then from Sales order L & S codes will be printed i.e LBJ & S23 with the given input. |
As expected, appropriate label printed form required table. |
P |
SO –69164 Material – 10017741 Size – 658 Qty - 2 (any) |
Siba |
Deepak |
| SD009 |
For Customer specific labels: Execute ZSD_UPCLBL t.code with the below inputs. S.org,Cust,Material,size,Qty |
The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK904 Sales org. KOTK922 Sales org./Distr. Chl/Division/Plant When multiple condition record available i.e for table 901 & 904. Then the condition record from 901 table should be used to print the labels ie., LBJ,S23 with given input quantities. |
As expected, appropriate label printed form required table. |
P |
S.org – 2000 Customer – 1000018 Material – 10000218 Size – 612 Qty – 2 (any) |
Siba |
Deepak |
| SD010 |
For Stock items: Execute ZSD_UPCLBL t.code with the below inputs. Material,size,qty,S.org,cur |
The condition record should be fetched from the below tables in a series. KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr KOTK906 Sales org./Distr. Chl/Division/Customer KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material KOTK908 Sales org./Distr. Chl/Division/Customer/Material KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr KOTK909 Sales org./Distr. Chl/Division/Customer/Usage KOTK902 Sales org./PO type KOTK904 Sales org. KOTK922 Sales org./Distr. Chl/Division/Plant When no condition records are available for the above table with given input, then output message ' No relevant L-Code or S-Code found' should appear. |
As expected, appropriate message displayed and no label printed. |
P |
Material – 10014184 Size – OSFA qty – 5 S.org – 2000 Cur – GBP MSRP – Blank |
Siba |
Deepak |